package jpa.entitys.promis.sales;

import java.io.Serializable;

import javax.persistence.*;

import java.math.BigDecimal;
import java.util.Date;

import jpa.entitys.common.CommonEntity;


/**
 * The persistent class for the MKT_REQUEST_TO_DTL database table.
 * 
 */
@Entity
@Table(name="MKT_REQUEST_TO_DTL")
@NamedQueries({
    @NamedQuery(name = "MktRequestToDtl.findAll", query = " SELECT c FROM MktRequestToDtl c "),
    @NamedQuery(name = "MktRequestToDtl.findById", query = " SELECT c FROM MktRequestToDtl c WHERE c.id = :Id "),
    @NamedQuery(name = "MktRequestToDtl.findByStatus", query = " SELECT c FROM MktRequestToDtl c WHERE c.syncIsstaging = 'N'"),
})
public class MktRequestToDtl extends CommonEntity implements Serializable {
	private static final long serialVersionUID = 1L;

	@EmbeddedId
	private MktRequestToDtlPK id;
	
	@Override public String toString() { return org.apache.commons.lang.builder.ToStringBuilder.reflectionToString(this);}

	@Column(name="BUILDING_PHASE_TO")
	private String buildingPhaseTo;

	@Column(name="COMPANY_TO")
	private String companyTo;

	@Column(name="CONTRACT_NUMBER")
	private BigDecimal contractNumber;

	@Column(name="CONTRACT_SERIES")
	private String contractSeries;

	@Column(name="CREATED_BY")
	private String createdBy;

    @Temporal( TemporalType.TIMESTAMP)
	@Column(name="CREATED_ON")
	private Date createdOn;

	@Column(name="EXT_REF_KEY")
	private String extRefKey;

	@Column(name="EXT_REF_NO")
	private String extRefNo;

	@Column(name="FLOOR_ZONE_TO")
	private String floorZoneTo;

	@Column(name="INSTANCE_NO")
	private String instanceNo;

	private String issync;

	@Column(name="LAST_UPD_BY")
	private String lastUpdBy;

    @Temporal( TemporalType.TIMESTAMP)
	@Column(name="LAST_UPD_ON")
	private Date lastUpdOn;

	@Column(name="MSG_ACT_RESULT")
	private String msgActResult;

	@Column(name="MSG_ALT_DESC")
	private String msgAltDesc;

	@Column(name="MSG_CODE")
	private String msgCode;

	@Column(name="MSG_DESC")
	private String msgDesc;

	@Column(name="PROJECT_TO")
	private String projectTo;

	@Column(name="PROPERTY_TYPE_TO")
	private String propertyTypeTo;

	@Column(name="REVISION_NUMBER")
	private BigDecimal revisionNumber;

	@Column(name="SYNC_CREATEDBY")
	private String syncCreatedby;

    @Temporal( TemporalType.TIMESTAMP)
	@Column(name="SYNC_CREATEDON")
	private Date syncCreatedon;

	@Column(name="SYNC_ISSTAGING")
	private String syncIsstaging;

	@Column(name="SYNC_PK_ID")
	private String syncPkId;

	@Column(name="SYNC_UPDATEDBY")
	private String syncUpdatedby;

    @Temporal( TemporalType.TIMESTAMP)
	@Column(name="SYNC_UPDATEDON")
	private Date syncUpdatedon;

	@Column(name="TYPE_OF_CONTRACT")
	private String typeOfContract;

	@Column(name="UNIT_NUMBER_TO")
	private String unitNumberTo;

	@Column(name="UNIT_PRICE_TO")
	private BigDecimal unitPriceTo;

    @Temporal( TemporalType.TIMESTAMP)
	@Column(name="VOUCHER_DATE")
	private Date voucherDate;

    public MktRequestToDtl() {
    }

	public MktRequestToDtlPK getId() {
		return this.id;
	}

	public void setId(MktRequestToDtlPK id) {
		this.id = id;
	}
	
	public String getBuildingPhaseTo() {
		return this.buildingPhaseTo;
	}

	public void setBuildingPhaseTo(String buildingPhaseTo) {
		this.buildingPhaseTo = buildingPhaseTo;
	}

	public String getCompanyTo() {
		return this.companyTo;
	}

	public void setCompanyTo(String companyTo) {
		this.companyTo = companyTo;
	}

	public BigDecimal getContractNumber() {
		return this.contractNumber;
	}

	public void setContractNumber(BigDecimal contractNumber) {
		this.contractNumber = contractNumber;
	}

	public String getContractSeries() {
		return this.contractSeries;
	}

	public void setContractSeries(String contractSeries) {
		this.contractSeries = contractSeries;
	}

	public String getCreatedBy() {
		return this.createdBy;
	}

	public void setCreatedBy(String createdBy) {
		this.createdBy = createdBy;
	}

	public Date getCreatedOn() {
		return this.createdOn;
	}

	public void setCreatedOn(Date createdOn) {
		this.createdOn = createdOn;
	}

	public String getExtRefKey() {
		return this.extRefKey;
	}

	public void setExtRefKey(String extRefKey) {
		this.extRefKey = extRefKey;
	}

	public String getExtRefNo() {
		return this.extRefNo;
	}

	public void setExtRefNo(String extRefNo) {
		this.extRefNo = extRefNo;
	}

	public String getFloorZoneTo() {
		return this.floorZoneTo;
	}

	public void setFloorZoneTo(String floorZoneTo) {
		this.floorZoneTo = floorZoneTo;
	}

	public String getInstanceNo() {
		return this.instanceNo;
	}

	public void setInstanceNo(String instanceNo) {
		this.instanceNo = instanceNo;
	}

	public String getIssync() {
		return this.issync;
	}

	public void setIssync(String issync) {
		this.issync = issync;
	}

	public String getLastUpdBy() {
		return this.lastUpdBy;
	}

	public void setLastUpdBy(String lastUpdBy) {
		this.lastUpdBy = lastUpdBy;
	}

	public Date getLastUpdOn() {
		return this.lastUpdOn;
	}

	public void setLastUpdOn(Date lastUpdOn) {
		this.lastUpdOn = lastUpdOn;
	}

	public String getMsgActResult() {
		return this.msgActResult;
	}

	public void setMsgActResult(String msgActResult) {
		this.msgActResult = msgActResult;
	}

	public String getMsgAltDesc() {
		return this.msgAltDesc;
	}

	public void setMsgAltDesc(String msgAltDesc) {
		this.msgAltDesc = msgAltDesc;
	}

	public String getMsgCode() {
		return this.msgCode;
	}

	public void setMsgCode(String msgCode) {
		this.msgCode = msgCode;
	}

	public String getMsgDesc() {
		return this.msgDesc;
	}

	public void setMsgDesc(String msgDesc) {
		this.msgDesc = msgDesc;
	}

	public String getProjectTo() {
		return this.projectTo;
	}

	public void setProjectTo(String projectTo) {
		this.projectTo = projectTo;
	}

	public String getPropertyTypeTo() {
		return this.propertyTypeTo;
	}

	public void setPropertyTypeTo(String propertyTypeTo) {
		this.propertyTypeTo = propertyTypeTo;
	}

	public BigDecimal getRevisionNumber() {
		return this.revisionNumber;
	}

	public void setRevisionNumber(BigDecimal revisionNumber) {
		this.revisionNumber = revisionNumber;
	}

	public String getSyncCreatedby() {
		return this.syncCreatedby;
	}

	public void setSyncCreatedby(String syncCreatedby) {
		this.syncCreatedby = syncCreatedby;
	}

	public Date getSyncCreatedon() {
		return this.syncCreatedon;
	}

	public void setSyncCreatedon(Date syncCreatedon) {
		this.syncCreatedon = syncCreatedon;
	}

	public String getSyncIsstaging() {
		return this.syncIsstaging;
	}

	public void setSyncIsstaging(String syncIsstaging) {
		this.syncIsstaging = syncIsstaging;
	}

	public String getSyncPkId() {
		return this.syncPkId;
	}

	public void setSyncPkId(String syncPkId) {
		this.syncPkId = syncPkId;
	}

	public String getSyncUpdatedby() {
		return this.syncUpdatedby;
	}

	public void setSyncUpdatedby(String syncUpdatedby) {
		this.syncUpdatedby = syncUpdatedby;
	}

	public Date getSyncUpdatedon() {
		return this.syncUpdatedon;
	}

	public void setSyncUpdatedon(Date syncUpdatedon) {
		this.syncUpdatedon = syncUpdatedon;
	}

	public String getTypeOfContract() {
		return this.typeOfContract;
	}

	public void setTypeOfContract(String typeOfContract) {
		this.typeOfContract = typeOfContract;
	}

	public String getUnitNumberTo() {
		return this.unitNumberTo;
	}

	public void setUnitNumberTo(String unitNumberTo) {
		this.unitNumberTo = unitNumberTo;
	}

	public BigDecimal getUnitPriceTo() {
		return this.unitPriceTo;
	}

	public void setUnitPriceTo(BigDecimal unitPriceTo) {
		this.unitPriceTo = unitPriceTo;
	}

	public Date getVoucherDate() {
		return this.voucherDate;
	}

	public void setVoucherDate(Date voucherDate) {
		this.voucherDate = voucherDate;
	}

}